MySqlDialectProviderBase<TDialect>

Assembly: ServiceStack.OrmLite.MySql.dll

View Source

Declaration

public abstract class MySqlDialectProviderBase<TDialect> : OrmLiteDialectProviderBase<TDialect>, IOrmLiteDialectProvider where TDialect : IOrmLiteDialectProvider

Fields

RowVersionTriggerFormat

View Source

Declaration

public static string RowVersionTriggerFormat

ReservedWords

View Source

Declaration

public static HashSet<string> ReservedWords

Methods

GetLoadChildrenSubSelect<From>(SqlExpression<From>)

View Source

Declaration

public override string GetLoadChildrenSubSelect<From>(SqlExpression<From> expr)

Returns

System.String

Parameters

Type	Name
ServiceStack.OrmLite.SqlExpression<T>	expr

Type Parameters

• From

ToPostDropTableStatement(ModelDefinition)

View Source

Declaration

public override string ToPostDropTableStatement(ModelDefinition modelDef)

Returns

System.String

Parameters

Type	Name
ServiceStack.OrmLite.ModelDefinition	modelDef

ToPostCreateTableStatement(ModelDefinition)

View Source

Declaration

public override string ToPostCreateTableStatement(ModelDefinition modelDef)

Returns

System.String

Parameters

Type	Name
ServiceStack.OrmLite.ModelDefinition	modelDef

GetQuotedValue(String)

View Source

Declaration

public override string GetQuotedValue(string paramValue)

Returns

System.String

Parameters

Type	Name
System.String	paramValue

GetQuotedValue(Object, Type)

View Source

Declaration

public override string GetQuotedValue(object value, Type fieldType)

Returns

System.String

Parameters

Type	Name
System.Object	value
Type	fieldType

GetTableName(String, String)

View Source

Declaration

public override string GetTableName(string table, string schema = null)

Returns

System.String

Parameters

Type	Name
System.String	table
System.String	schema

GetTableName(String, String, Boolean)

View Source

Declaration

public override string GetTableName(string table, string schema, bool useStrategy)

Returns

System.String

Parameters

Type	Name
System.String	table
System.String	schema
System.Boolean	useStrategy

ShouldQuote(String)

View Source

Declaration

public override bool ShouldQuote(string name)

Returns

System.Boolean

Parameters

Type	Name
System.String	name

GetQuotedName(String)

View Source

Declaration

public override string GetQuotedName(string name)

Returns

System.String

Parameters

Type	Name
System.String	name

GetQuotedTableName(String, String)

View Source

Declaration

public override string GetQuotedTableName(string tableName, string schema = null)

Returns

System.String

Parameters

Type	Name
System.String	tableName
System.String	schema

SqlExpression<T>()

View Source

Declaration

public override SqlExpression<T> SqlExpression<T>()

Returns

ServiceStack.OrmLite.SqlExpression<T>

Type Parameters

• T

ToTableNamesStatement(String)

View Source

Declaration

public override string ToTableNamesStatement(string schema)

Returns

System.String

Parameters

Type	Name
System.String	schema

ToTableNamesWithRowCountsStatement(Boolean, String)

View Source

Declaration

public override string ToTableNamesWithRowCountsStatement(bool live, string schema)

Returns

System.String

Parameters

Type	Name
System.Boolean	live
System.String	schema

DoesTableExist(IDbCommand, String, String)

View Source

Declaration

public override bool DoesTableExist(IDbCommand dbCmd, string tableName, string schema = null)

Returns

System.Boolean

Parameters

Type	Name
IDbCommand	dbCmd
System.String	tableName
System.String	schema

DoesTableExistAsync(IDbCommand, String, String, CancellationToken)

View Source

Declaration

public override async Task<bool> DoesTableExistAsync(IDbCommand dbCmd, string tableName, string schema = null, CancellationToken token = null)

Returns

Task<System.Boolean>

Parameters

Type	Name
IDbCommand	dbCmd
System.String	tableName
System.String	schema
CancellationToken	token

DoesColumnExist(IDbConnection, String, String, String)

View Source

Declaration

public override bool DoesColumnExist(IDbConnection db, string columnName, string tableName, string schema = null)

Returns

System.Boolean

Parameters

Type	Name
IDbConnection	db
System.String	columnName
System.String	tableName
System.String	schema

DoesColumnExistAsync(IDbConnection, String, String, String, CancellationToken)

View Source

Declaration

public override async Task<bool> DoesColumnExistAsync(IDbConnection db, string columnName, string tableName, string schema = null, CancellationToken token = null)

Returns

Task<System.Boolean>

Parameters

Type	Name
IDbConnection	db
System.String	columnName
System.String	tableName
System.String	schema
CancellationToken	token

ToCreateTableStatement(Type)

View Source

Declaration

public override string ToCreateTableStatement(Type tableType)

Returns

System.String

Parameters

Type	Name
Type	tableType

GetSchemas(IDbCommand)

View Source

Declaration

public override List<string> GetSchemas(IDbCommand dbCmd)

Returns

List<System.String>

Parameters

Type	Name
IDbCommand	dbCmd

GetSchemaTables(IDbCommand)

View Source

Declaration

public override Dictionary<string, List<string>> GetSchemaTables(IDbCommand dbCmd)

Returns

Dictionary<System.String,List<System.String>>

Parameters

Type	Name
IDbCommand	dbCmd

DoesSchemaExist(IDbCommand, String)

View Source

Declaration

public override bool DoesSchemaExist(IDbCommand dbCmd, string schemaName)

Returns

System.Boolean

Parameters

Type	Name
IDbCommand	dbCmd
System.String	schemaName

ToCreateSchemaStatement(String)

View Source

Declaration

public override string ToCreateSchemaStatement(string schemaName)

Returns

System.String

Parameters

Type	Name
System.String	schemaName

GetColumnDefinition(FieldDefinition)

View Source

Declaration

public override string GetColumnDefinition(FieldDefinition fieldDef)

Returns

System.String

Parameters

Type	Name
ServiceStack.OrmLite.FieldDefinition	fieldDef

SqlConflict(String, String)

View Source

Declaration

public override string SqlConflict(string sql, string conflictResolution)

Returns

System.String

Parameters

Type	Name
System.String	sql
System.String	conflictResolution

SqlCurrency(String, String)

View Source

Declaration

public override string SqlCurrency(string fieldOrValue, string currencySymbol)

Returns

System.String

Parameters

Type	Name
System.String	fieldOrValue
System.String	currencySymbol

SqlCast(Object, String)

View Source

Declaration

public override string SqlCast(object fieldOrValue, string castAs)

Returns

System.String

Parameters

Type	Name
System.Object	fieldOrValue
System.String	castAs

SqlBool(Boolean)

View Source

Declaration

public override string SqlBool(bool value)

Returns

System.String

Parameters

Type	Name
System.Boolean	value

EnableForeignKeysCheck(IDbCommand)

View Source

Declaration

public override void EnableForeignKeysCheck(IDbCommand cmd)

Parameters

Type	Name
IDbCommand	cmd

EnableForeignKeysCheckAsync(IDbCommand, CancellationToken)

View Source

Declaration

public override Task EnableForeignKeysCheckAsync(IDbCommand cmd, CancellationToken token = null)

Returns

Task

Parameters

Type	Name
IDbCommand	cmd
CancellationToken	token

DisableForeignKeysCheck(IDbCommand)

View Source

Declaration

public override void DisableForeignKeysCheck(IDbCommand cmd)

Parameters

Type	Name
IDbCommand	cmd

DisableForeignKeysCheckAsync(IDbCommand, CancellationToken)

View Source

Declaration

public override Task DisableForeignKeysCheckAsync(IDbCommand cmd, CancellationToken token = null)

Returns

Task

Parameters

Type	Name
IDbCommand	cmd
CancellationToken	token

Unwrap(IDbConnection)

View Source

Declaration

protected DbConnection Unwrap(IDbConnection db)

Returns

DbConnection

Parameters

Type	Name
IDbConnection	db

Unwrap(IDbCommand)

View Source

Declaration

protected DbCommand Unwrap(IDbCommand cmd)

Returns

DbCommand

Parameters

Type	Name
IDbCommand	cmd

Unwrap(IDataReader)

View Source

Declaration

protected DbDataReader Unwrap(IDataReader reader)

Returns

DbDataReader

Parameters

Type	Name
IDataReader	reader

OpenAsync(IDbConnection, CancellationToken)

View Source

Declaration

public override Task OpenAsync(IDbConnection db, CancellationToken token = null)

Returns

Task

Parameters

Type	Name
IDbConnection	db
CancellationToken	token

ExecuteReaderAsync(IDbCommand, CancellationToken)

View Source

Declaration

public override Task<IDataReader> ExecuteReaderAsync(IDbCommand cmd, CancellationToken token = null)

Returns

Task<IDataReader>

Parameters

Type	Name
IDbCommand	cmd
CancellationToken	token

ExecuteNonQueryAsync(IDbCommand, CancellationToken)

View Source

Declaration

public override Task<int> ExecuteNonQueryAsync(IDbCommand cmd, CancellationToken token = null)

Returns

Task<System.Int32>

Parameters

Type	Name
IDbCommand	cmd
CancellationToken	token

ExecuteScalarAsync(IDbCommand, CancellationToken)

View Source

Declaration

public override Task<object> ExecuteScalarAsync(IDbCommand cmd, CancellationToken token = null)

Returns

Task<System.Object>

Parameters

Type	Name
IDbCommand	cmd
CancellationToken	token

ReadAsync(IDataReader, CancellationToken)

View Source

Declaration

public override Task<bool> ReadAsync(IDataReader reader, CancellationToken token = null)

Returns

Task<System.Boolean>

Parameters

Type	Name
IDataReader	reader
CancellationToken	token

ReaderEach<T>(IDataReader, Func<T>, CancellationToken)

View Source

Declaration

public override async Task<List<T>> ReaderEach<T>(IDataReader reader, Func<T> fn, CancellationToken token = null)

Returns

Task<List<<T>>>

Parameters

Type	Name
IDataReader	reader
Func<<T>>	fn
CancellationToken	token

Type Parameters

• T

ReaderEach<Return>(IDataReader, Action, Return, CancellationToken)

View Source

Declaration

public override async Task<Return> ReaderEach<Return>(IDataReader reader, Action fn, Return source, CancellationToken token = null)

Returns

Task<<Return>>

Parameters

Type	Name
IDataReader	reader
Action	fn
<Return>	source
CancellationToken	token

Type Parameters

• Return

ReaderRead<T>(IDataReader, Func<T>, CancellationToken)

View Source

Declaration

public override async Task<T> ReaderRead<T>(IDataReader reader, Func<T> fn, CancellationToken token = null)

Returns

Task<<T>>

Parameters

Type	Name
IDataReader	reader
Func<<T>>	fn
CancellationToken	token

Type Parameters

• T

Implements

• ServiceStack.OrmLite.IOrmLiteDialectProvider